/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : localhost:3306
 Source Schema         : xms_account

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 08/02/2021 22:59:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for product_file_category
-- ----------------------------
DROP TABLE IF EXISTS `product_file_category`;
CREATE TABLE `product_file_category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `parent_id` int(11) NULL DEFAULT NULL COMMENT '上级编号',
  `pf_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
  `pf_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `pf_state` int(11) NULL DEFAULT 1 COMMENT '状态(1:正常;0:作废)',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `product_file_category_pf_code_uindex`(`pf_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '存货档案类别';

-- ----------------------------
-- Records of product_file_category
-- ----------------------------
BEGIN;
INSERT INTO `product_file_category` VALUES (1, NULL, NULL, '存货大类', 1), (2, 1, '01', '原料及主要材料', 1), (3, 1, '02', '辅助材料', 1), (4, 1, '03', '刀模模板', 1), (5, 1, '04', '外购自社再加工及外购部品', 1), (7, 1, '05', '低值易耗品', 1), (8, 1, '06', '成品及外生产成品', 1), (9, 1, '07', '印刷成品', 1), (10, 1, '08', '印刷半成品及托盘半成品', 1), (11, 1, '09', '印刷原材料', 1), (12, 1, '10', '组装托盘', 1), (13, 1, '11', '来料加工', 1), (14, 2, '0101', '纸芯', 1), (15, 2, '0102', '原纸', 1), (16, 2, '0103', '液体乳胶', 1), (17, 3, '0201', '缠绕膜', 1), (18, 3, '0202', '石蜡', 1), (19, 3, '0203', '热熔胶', 1), (20, 3, '0204', '扁丝', 1), (21, 3, '0205', '油墨', 1), (22, 3, '0299', '其他', 1), (23, 4, '0301', '刀模', 1), (24, 4, '0302', '印版', 1), (25, 5, '0401', '自社加工纸箱', 1), (26, 5, '0402', '自社加工隔板', 1), (27, 5, '0403', '自社加工纸护角', 1), (28, 5, '0404', '自社加工木制托盘', 1), (29, 5, '0405', '自社加工纸托盘', 1), (30, 5, '0406', '纸托盘部件', 1), (31, 5, '0411', '纸箱', 1), (32, 5, '0412', '隔板', 1), (33, 5, '0413', '纸护角', 1), (34, 5, '0414', '木托盘', 1), (35, 5, '0415', '木制托盘', 1), (36, 8, '0601', '蜂窝板蜂窝块', 1), (37, 1, '99', '旧编码', 1), (38, 11, '0901', '纸箱用平板', 1), (39, 11, '0902', '天盖底部瓦楞', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
